
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[UserInfoSelectAll]
AS 
    BEGIN
        SELECT  Id ,
                FirstName ,
                LastName ,
                Login ,
                Password ,
                DateCreated ,
                Admin ,
                Active ,
                Visible ,
                Deleted
        FROM    UserInfo
        WHERE   Deleted = 0
        ORDER BY LastName
    END
GO
